package com.maikang.exammall.repository;

import com.maikang.exammall.entity.GroupRegistry;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

public interface GroupRegistryRepository extends BaseRepository<GroupRegistry, Long>, JpaSpecificationExecutor<GroupRegistry> {

    @Query("SELECT count(g.id) FROM GroupRegistry g GROUP BY g.companyName")
    Long countCompany();

}